<?php
/* wwwschool project

Copyright (C) 2009  Phillip Aldridge
Email : info@imi21.com
Web site http://www.imi21.com

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/


/**
 *  File : listCourses.php
 *  called only via ajax 
 *  List all the courses in the table 'course'
 */  
 
checkSession();

require '../../includes/classes/WS3tableview.php';
$message="";

$table=new WS3_TableView('main',400);
$table->setTitle( 'Listing Courses' );
//$table->addColumnTH('Classrooms');
//$table->addColumnTH('Teachers');
$table->addColumnTH('Name');

if ($session->userType() < 3) // only admin and headmaster
{
  $table->addColumnActive(true,'course');
  $table->addColumnEdit(true,'Course');
  $table->addColumnDelete(true,'Course');
}
$table->addColumn('Lessons','listLessons');
$table->setAlternativeRows(true);
$table->setInfoRow(true);


$db=new WS3_Database();
//$count = $db->totalRows("course");


$q="SELECT * FROM `course` WHERE 1 ORDER BY `name`";

if ($db->query($q))
{
  $count = $db->numberRows();
  while ( $db->nextRecord() )
  {
     $table->addRow($db->f('id'), array(
      'Name'=>javaSafeString( $db->f('name') ),
      //'Classrooms'=>$db->f('classroom_id'),
      //'Teachers'=>$db->f('teacher_id'),             
       'active'=>$db->f('active')
          ));
  }
  $table->addToInfoRow("<p>Count = $count </p>");
  echo $table->display();
  $message="Listing";
}else{
  $message="Error : Empty list";
}

  /** Get menu */
  require '../../includes/menus/topCourses.php';
  $menu=javaSafeString($menu);
  echo "document.getElementById('topmenu').innerHTML='$menu';";  
  
  echo "document.getElementById('messages').innerHTML='$message';";

if (W3DEBUG) $debug=new WS3_Debug();

?>
